﻿IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[RA_getUserById_sp]') AND type in (N'P'))
DROP PROCEDURE [dbo].[RA_getUserById_sp]
go

CREATE PROCEDURE dbo.RA_getUserById_sp
(
	@id	int
)
AS
	SET NOCOUNT ON
	
	select	id,
			username,
			passwordHash,
			emailAddress,
			creationDate,
			enabled
	from	RA_Users
	where 	id=@id